package br.com.bancodados.model;

import android.provider.BaseColumns;

public class CarrosBaseHelper implements BaseColumns{
	
	public static final String MARCA    = "marca";
	public static final String MODELO   = "modelo";
	public static final String CHASSI   = "chassi";
	public static final String PLACA    = "placa";
	public static final String COR      = "cor";
	
	private static String[] colunas = new String[] { CarrosBaseHelper._ID, CarrosBaseHelper.MARCA, CarrosBaseHelper.MODELO, 
  		CarrosBaseHelper.CHASSI, CarrosBaseHelper.PLACA, CarrosBaseHelper.COR};
	
	public static String[] getCarroColunas(){
		return colunas;
	}
	
	public static String[] SCRIPT_DATABASE_CREATE = new String[] {
		"CREATE TABLE carro ( _id integer primary key autoincrement, marca text not null, modelo text not null" +
		",chassi text not null,placa text not null, cor text not null);",
		"insert into carro(marca,modelo,chassi,placa,cor) values('VW','Gol','035BAC','KKK5555','Prata');",
		"insert into carro(marca,modelo,chassi,placa,cor) values('Fiat','Uno','03TGSC','KKK8888','Preto');",
		"insert into carro(marca,modelo,chassi,placa,cor) values('GM','Corsa','085BAC','KKK7777','Azul');",
		"insert into carro(marca,modelo,chassi,placa,cor) values('Ford','Focus','035S8C','KPP5855','Vermelho');",
		"insert into carro(marca,modelo,chassi,placa,cor) values('Jac','J3','0856AC','KVW9855','Amarelo');"
	
		
	};
	
	public static  String SCRIPT_DATABASE_DELETE = "DROP TABLE IF EXISTS carro";
}


